Into the query window, paste the following T-SQL code snippet:
SQL

USE master
GO
IF NOT EXISTS (
   SELECT name
   FROM sys.databases
   WHERE name = N'TutorialDB'
)
CREATE DATABASE [TutorialDB]
GO

To execute the query, select Execute (or select F5 on your keyboard). 
 

      
After the query is complete, the new TutorialDB database appears in the list of databases in Object Explorer. If it isn't displayed, right-click the Databases node, and then select Refresh. 
 

      
SQL

-- Create a new table called 'Customers' in schema 'dbo'
-- Drop the table if it already exists
IF OBJECT_ID('dbo.Customers', 'U') IS NOT NULL
DROP TABLE dbo.Customers
GO
-- Create the table in the specified schema
CREATE TABLE dbo.Customers
(
   CustomerId        INT    NOT NULL   PRIMARY KEY, -- primary key column
   Name      [NVARCHAR](50)  NOT NULL,
   Location  [NVARCHAR](50)  NOT NULL,
   Email     [NVARCHAR](50)  NOT NULL
);
GO 
 

      
SQL

-- Insert rows into table 'Customers'
INSERT INTO dbo.Customers
   ([CustomerId],[Name],[Location],[Email])
VALUES
   ( 1, N'Orlando', N'Australia', N''),
   ( 2, N'Keith', N'India', N'keith0@adventure-works.com'),
   ( 3, N'Donna', N'Germany', N'donna0@adventure-works.com'),
   ( 4, N'Janet', N'United States', N'janet1@adventure-works.com')
GO
 
 

      
Paste the following T-SQL code snippet into the query window, and then select Execute:
SQL

-- Select rows from table 'Customers'
SELECT * FROM dbo.Customers; 
 

      
update Customers set Name='raj' where CustomerId=1 
 

      
delete from Customers where CustomerId=1 
 

      
SELECT * FROM Customers
ORDER BY Location 
 

      
SELECT distinct Location FROM Customers; 
 

      
SELECT * FROM Customers
where Location is null 
 

      
SELECT top 10 * FROM Customers 
 

      
SELECT MIN(Price) AS SmallestPrice
FROM Products; 
 

      
SELECT MAX(Price) AS LargestPrice
FROM Products;  
 

      
SELECT count(*) as TotalRecords FROM Customers 
 

      
SELECT AVG(Price)
FROM Products; 
 

      
SELECT SUM(Quantity)
FROM OrderDetails;  
 

      
SELECT * FROM Customers wher Location like '%tamilnadu%' 
 

      
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name; 
 

      
SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name; 
 

      
SELECT column_name(s)
FROM table1
RIGHT JOIN table2
ON table1.column_name = table2.column_name; 
 

      
SELECT column_name(s)
FROM table1
FULL OUTER JOIN table2
ON table1.column_name = table2.column_name
WHERE condition;  
 

      
SELECT column_name(s)
FROM table1 T1, table1 T2
WHERE condition; 
 

      
SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2;  
 

      
SELECT column_name(s)
FROM table_name
WHERE condition
GROUP BY column_name(s)
ORDER BY column_name(s);  
 

      
SELECT column_name(s)
FROM table_name
WHERE condition
GROUP BY column_name(s)
HAVING condition
ORDER BY column_name(s);